Mega Code Archive
Logical Functions
1) =AND(1A2, A2100)
2) =AND(2+2=4, 2+3=5)
3) =IF(A1A2, A1, A2)
4) =IF(A1A2, Good!, Bad!)
5) =IF(A2=100,SUM(B5
6) =IF(A289,A,IF(A279,B, IF(A269,C,IF(A259,D,F))))
7) =IF(AND(1A3, A3100), A3, The value is out of range )
8) =NOT(1+1=2)
9) =OR(1+1=1,2+2=5)
10) =OR(TRUE,FALSE,TRUE)
11) AND(logical1,logical2, ) returns TRUE if all of its arguments are TRUE
12) Combine IF, AND and CHOOSE to display month name
13) Combine IF, OR and CHOOSE to display month name
14) FALSE() returns the logical value FALSE
15) IF(logical_test,value_if_true,value_if_false) specifies a logical test
16) IFERROR(value,value_if_error) returns a value in case of an error; otherwise, returns the result of the formula
17) Making an Error Behave the Way You Want
18) NOT(logical) reverses the logic of its argument
19) OR(logical1,logical2, ) returns TRUE if any argument is TRUE
20) TRUE( ) returns the logical value TRUE